﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="DsTransactions" targetNamespace="http://tempuri.org/DsTransactions.xsd" xmlns:mstns="http://tempuri.org/DsTransactions.xsd" xmlns="http://tempuri.org/DsTransactions.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="1" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="MySettings" AppSettingsPropertyName="RundConnectionString" IsAppSettingsProperty="true" Modifier="Assembly" Name="RundConnectionString (MySettings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.OasisIBS.My.MySettings.GlobalReference.Default.RundConnectionString" Provider="System.Data.SqlClient" />
          <Connection AppSettingsObjectName="MySettings" AppSettingsPropertyName="LonsdaleConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="LonsdaleConnectionString (MySettings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.OasisIBS.My.MySettings.GlobalReference.Default.LonsdaleConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="TransactionsTableAdapter" GeneratorDataComponentClassName="TransactionsTableAdapter" Name="Transactions" UserDataComponentName="TransactionsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="LonsdaleConnectionString (MySettings)" DbObjectName="Lonsdale.dbo.Transactions" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Transactions] WHERE (([SNo] = @Original_SNo) AND ((@IsNull_Branch = 1 AND [Branch] IS NULL) OR ([Branch] = @Original_Branch)) AND ((@IsNull_Source = 1 AND [Source] IS NULL) OR ([Source] = @Original_Source)) AND ((@IsNull_TransType = 1 AND [TransType] IS NULL) OR ([TransType] = @Original_TransType)) AND ((@IsNull_PaperNo = 1 AND [PaperNo] IS NULL) OR ([PaperNo] = @Original_PaperNo)) AND ((@IsNull_MoveNo = 1 AND [MoveNo] IS NULL) OR ([MoveNo] = @Original_MoveNo)) AND ((@IsNull_DestSource = 1 AND [DestSource] IS NULL) OR ([DestSource] = @Original_DestSource)) AND ((@IsNull_ReceivedBy = 1 AND [ReceivedBy] IS NULL) OR ([ReceivedBy] = @Original_ReceivedBy)) AND ((@IsNull_Descr = 1 AND [Descr] IS NULL) OR ([Descr] = @Original_Descr)) AND ((@IsNull_PolRef = 1 AND [PolRef] IS NULL) OR ([PolRef] = @Original_PolRef)) AND ((@IsNull_AccNo = 1 AND [AccNo] IS NULL) OR ([AccNo] = @Original_AccNo)) AND ((@IsNull_Acc1 = 1 AND [Acc1] IS NULL) OR ([Acc1] = @Original_Acc1)) AND ((@IsNull_Acc2 = 1 AND [Acc2] IS NULL) OR ([Acc2] = @Original_Acc2)) AND ((@IsNull_Acc3 = 1 AND [Acc3] IS NULL) OR ([Acc3] = @Original_Acc3)) AND ((@IsNull_Acc4 = 1 AND [Acc4] IS NULL) OR ([Acc4] = @Original_Acc4)) AND ((@IsNull_ChNo = 1 AND [ChNo] IS NULL) OR ([ChNo] = @Original_ChNo)) AND ((@IsNull_TotalIn = 1 AND [TotalIn] IS NULL) OR ([TotalIn] = @Original_TotalIn)) AND ((@IsNull_TotalOut = 1 AND [TotalOut] IS NULL) OR ([TotalOut] = @Original_TotalOut)) AND ((@IsNull_Writting = 1 AND [Writting] IS NULL) OR ([Writting] = @Original_Writting)) AND ((@IsNull_Reversed = 1 AND [Reversed] IS NULL) OR ([Reversed] = @Original_Reversed)) AND ((@IsNull_SavedUser = 1 AND [SavedUser] IS NULL) OR ([SavedUser] = @Original_SavedUser)) AND ((@IsNull_TransDate = 1 AND [TransDate] IS NULL) OR ([TransDate] = @Original_TransDate)) AND ((@IsNull_ApprovedUser = 1 AND [ApprovedUser] IS NULL) OR ([ApprovedUser] = @Original_ApprovedUser)) AND ((@IsNull_ApprovedDate = 1 AND [ApprovedDate] IS NULL) OR ([ApprovedDate] = @Original_ApprovedDate)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_SNo" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="SNo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Branch" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Branch" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Branch" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Branch" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Source" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Source" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Source" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Source" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TransType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TransType" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_TransType" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TransType" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PaperNo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PaperNo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_PaperNo" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="PaperNo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_MoveNo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MoveNo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_MoveNo" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="MoveNo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DestSource" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DestSource" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_DestSource" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DestSource" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ReceivedBy" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ReceivedBy" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ReceivedBy" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ReceivedBy" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Descr" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Descr" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Descr" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Descr" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PolRef" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PolRef" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_PolRef" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="PolRef" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_AccNo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AccNo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_AccNo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="AccNo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Acc1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Acc1" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Acc1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Acc1" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Acc2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Acc2" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Acc2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Acc2" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Acc3" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Acc3" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Acc3" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Acc3" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Acc4" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Acc4" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Acc4" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Acc4" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ChNo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ChNo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ChNo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ChNo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TotalIn" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TotalIn" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_TotalIn" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="TotalIn" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TotalOut" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TotalOut" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_TotalOut" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="TotalOut" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Writting" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Writting" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Writting" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Writting" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Reversed" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Reversed" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Reversed" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Reversed" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_SavedUser" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SavedUser" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_SavedUser" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="SavedUser" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TransDate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TransDate" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_TransDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="TransDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ApprovedUser" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ApprovedUser" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ApprovedUser" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ApprovedUser" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ApprovedDate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ApprovedDate" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ApprovedDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ApprovedDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Transactions] ([Branch], [Source], [TransType], [PaperNo], [MoveNo], [DestSource], [ReceivedBy], [Descr], [PolRef], [AccNo], [Acc1], [Acc2], [Acc3], [Acc4], [ChNo], [TotalIn], [TotalOut], [Writting], [Reversed], [SavedUser], [TransDate], [ApprovedUser], [ApprovedDate]) VALUES (@Branch, @Source, @TransType, @PaperNo, @MoveNo, @DestSource, @ReceivedBy, @Descr, @PolRef, @AccNo, @Acc1, @Acc2, @Acc3, @Acc4, @ChNo, @TotalIn, @TotalOut, @Writting, @Reversed, @SavedUser, @TransDate, @ApprovedUser, @ApprovedDate);
SELECT SNo, Branch, Source, TransType, PaperNo, MoveNo, DestSource, ReceivedBy, Descr, PolRef, AccNo, Acc1, Acc2, Acc3, Acc4, ChNo, TotalIn, TotalOut, Writting, Reversed, SavedUser, TransDate, ApprovedUser, ApprovedDate FROM Transactions WHERE (SNo = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Branch" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Branch" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Source" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Source" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@TransType" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TransType" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@PaperNo" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="PaperNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@MoveNo" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="MoveNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@DestSource" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DestSource" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ReceivedBy" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ReceivedBy" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Descr" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Descr" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@PolRef" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="PolRef" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@AccNo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="AccNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Acc1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Acc1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Acc2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Acc2" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Acc3" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Acc3" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Acc4" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Acc4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ChNo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ChNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@TotalIn" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="TotalIn" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@TotalOut" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="TotalOut" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Writting" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Writting" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Reversed" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Reversed" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@SavedUser" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="SavedUser" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@TransDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="TransDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ApprovedUser" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ApprovedUser" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ApprovedDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ApprovedDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT SNo, Branch, Source, TransType, PaperNo, MoveNo, DestSource, ReceivedBy, Descr, PolRef, AccNo, Acc1, Acc2, Acc3, Acc4, ChNo, TotalIn, TotalOut, Writting, Reversed, SavedUser, TransDate, ApprovedUser, ApprovedDate FROM dbo.Transactions</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Transactions] SET [Branch] = @Branch, [Source] = @Source, [TransType] = @TransType, [PaperNo] = @PaperNo, [MoveNo] = @MoveNo, [DestSource] = @DestSource, [ReceivedBy] = @ReceivedBy, [Descr] = @Descr, [PolRef] = @PolRef, [AccNo] = @AccNo, [Acc1] = @Acc1, [Acc2] = @Acc2, [Acc3] = @Acc3, [Acc4] = @Acc4, [ChNo] = @ChNo, [TotalIn] = @TotalIn, [TotalOut] = @TotalOut, [Writting] = @Writting, [Reversed] = @Reversed, [SavedUser] = @SavedUser, [TransDate] = @TransDate, [ApprovedUser] = @ApprovedUser, [ApprovedDate] = @ApprovedDate WHERE (([SNo] = @Original_SNo) AND ((@IsNull_Branch = 1 AND [Branch] IS NULL) OR ([Branch] = @Original_Branch)) AND ((@IsNull_Source = 1 AND [Source] IS NULL) OR ([Source] = @Original_Source)) AND ((@IsNull_TransType = 1 AND [TransType] IS NULL) OR ([TransType] = @Original_TransType)) AND ((@IsNull_PaperNo = 1 AND [PaperNo] IS NULL) OR ([PaperNo] = @Original_PaperNo)) AND ((@IsNull_MoveNo = 1 AND [MoveNo] IS NULL) OR ([MoveNo] = @Original_MoveNo)) AND ((@IsNull_DestSource = 1 AND [DestSource] IS NULL) OR ([DestSource] = @Original_DestSource)) AND ((@IsNull_ReceivedBy = 1 AND [ReceivedBy] IS NULL) OR ([ReceivedBy] = @Original_ReceivedBy)) AND ((@IsNull_Descr = 1 AND [Descr] IS NULL) OR ([Descr] = @Original_Descr)) AND ((@IsNull_PolRef = 1 AND [PolRef] IS NULL) OR ([PolRef] = @Original_PolRef)) AND ((@IsNull_AccNo = 1 AND [AccNo] IS NULL) OR ([AccNo] = @Original_AccNo)) AND ((@IsNull_Acc1 = 1 AND [Acc1] IS NULL) OR ([Acc1] = @Original_Acc1)) AND ((@IsNull_Acc2 = 1 AND [Acc2] IS NULL) OR ([Acc2] = @Original_Acc2)) AND ((@IsNull_Acc3 = 1 AND [Acc3] IS NULL) OR ([Acc3] = @Original_Acc3)) AND ((@IsNull_Acc4 = 1 AND [Acc4] IS NULL) OR ([Acc4] = @Original_Acc4)) AND ((@IsNull_ChNo = 1 AND [ChNo] IS NULL) OR ([ChNo] = @Original_ChNo)) AND ((@IsNull_TotalIn = 1 AND [TotalIn] IS NULL) OR ([TotalIn] = @Original_TotalIn)) AND ((@IsNull_TotalOut = 1 AND [TotalOut] IS NULL) OR ([TotalOut] = @Original_TotalOut)) AND ((@IsNull_Writting = 1 AND [Writting] IS NULL) OR ([Writting] = @Original_Writting)) AND ((@IsNull_Reversed = 1 AND [Reversed] IS NULL) OR ([Reversed] = @Original_Reversed)) AND ((@IsNull_SavedUser = 1 AND [SavedUser] IS NULL) OR ([SavedUser] = @Original_SavedUser)) AND ((@IsNull_TransDate = 1 AND [TransDate] IS NULL) OR ([TransDate] = @Original_TransDate)) AND ((@IsNull_ApprovedUser = 1 AND [ApprovedUser] IS NULL) OR ([ApprovedUser] = @Original_ApprovedUser)) AND ((@IsNull_ApprovedDate = 1 AND [ApprovedDate] IS NULL) OR ([ApprovedDate] = @Original_ApprovedDate)));
SELECT SNo, Branch, Source, TransType, PaperNo, MoveNo, DestSource, ReceivedBy, Descr, PolRef, AccNo, Acc1, Acc2, Acc3, Acc4, ChNo, TotalIn, TotalOut, Writting, Reversed, SavedUser, TransDate, ApprovedUser, ApprovedDate FROM Transactions WHERE (SNo = @SNo)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Branch" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Branch" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Source" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Source" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@TransType" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TransType" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@PaperNo" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="PaperNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@MoveNo" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="MoveNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@DestSource" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DestSource" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ReceivedBy" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ReceivedBy" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Descr" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Descr" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@PolRef" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="PolRef" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@AccNo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="AccNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Acc1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Acc1" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Acc2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Acc2" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Acc3" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Acc3" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Acc4" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Acc4" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ChNo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ChNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@TotalIn" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="TotalIn" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@TotalOut" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="TotalOut" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Writting" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Writting" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Reversed" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Reversed" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@SavedUser" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="SavedUser" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@TransDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="TransDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ApprovedUser" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ApprovedUser" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ApprovedDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ApprovedDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_SNo" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="SNo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Branch" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Branch" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Branch" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Branch" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Source" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Source" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Source" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Source" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TransType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TransType" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_TransType" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TransType" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PaperNo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PaperNo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_PaperNo" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="PaperNo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_MoveNo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MoveNo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_MoveNo" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="MoveNo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DestSource" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DestSource" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_DestSource" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DestSource" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ReceivedBy" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ReceivedBy" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ReceivedBy" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ReceivedBy" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Descr" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Descr" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Descr" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Descr" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PolRef" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PolRef" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_PolRef" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="PolRef" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_AccNo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AccNo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_AccNo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="AccNo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Acc1" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Acc1" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Acc1" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Acc1" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Acc2" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Acc2" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Acc2" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Acc2" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Acc3" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Acc3" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Acc3" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Acc3" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Acc4" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Acc4" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Acc4" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Acc4" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ChNo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ChNo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ChNo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ChNo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TotalIn" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TotalIn" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_TotalIn" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="TotalIn" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TotalOut" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TotalOut" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_TotalOut" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="TotalOut" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Writting" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Writting" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Writting" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Writting" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Reversed" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Reversed" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Reversed" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Reversed" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_SavedUser" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SavedUser" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_SavedUser" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="SavedUser" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TransDate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TransDate" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_TransDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="TransDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ApprovedUser" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ApprovedUser" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ApprovedUser" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ApprovedUser" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ApprovedDate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ApprovedDate" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_ApprovedDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="ApprovedDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="SNo" ColumnName="SNo" DataSourceName="" DataTypeServer="bigint" DbType="Int64" Direction="Input" ParameterName="@SNo" Precision="0" ProviderType="BigInt" Scale="0" Size="8" SourceColumn="SNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="SNo" DataSetColumn="SNo" />
              <Mapping SourceColumn="Branch" DataSetColumn="Branch" />
              <Mapping SourceColumn="Source" DataSetColumn="Source" />
              <Mapping SourceColumn="TransType" DataSetColumn="TransType" />
              <Mapping SourceColumn="PaperNo" DataSetColumn="PaperNo" />
              <Mapping SourceColumn="MoveNo" DataSetColumn="MoveNo" />
              <Mapping SourceColumn="DestSource" DataSetColumn="DestSource" />
              <Mapping SourceColumn="ReceivedBy" DataSetColumn="ReceivedBy" />
              <Mapping SourceColumn="Descr" DataSetColumn="Descr" />
              <Mapping SourceColumn="PolRef" DataSetColumn="PolRef" />
              <Mapping SourceColumn="AccNo" DataSetColumn="AccNo" />
              <Mapping SourceColumn="Acc1" DataSetColumn="Acc1" />
              <Mapping SourceColumn="Acc2" DataSetColumn="Acc2" />
              <Mapping SourceColumn="Acc3" DataSetColumn="Acc3" />
              <Mapping SourceColumn="Acc4" DataSetColumn="Acc4" />
              <Mapping SourceColumn="ChNo" DataSetColumn="ChNo" />
              <Mapping SourceColumn="TotalIn" DataSetColumn="TotalIn" />
              <Mapping SourceColumn="TotalOut" DataSetColumn="TotalOut" />
              <Mapping SourceColumn="Writting" DataSetColumn="Writting" />
              <Mapping SourceColumn="Reversed" DataSetColumn="Reversed" />
              <Mapping SourceColumn="SavedUser" DataSetColumn="SavedUser" />
              <Mapping SourceColumn="TransDate" DataSetColumn="TransDate" />
              <Mapping SourceColumn="ApprovedUser" DataSetColumn="ApprovedUser" />
              <Mapping SourceColumn="ApprovedDate" DataSetColumn="ApprovedDate" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="DsTransactions" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="true" msprop:Generator_DataSetName="DsTransactions" msprop:Generator_UserDSName="DsTransactions">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="Transactions" msprop:Generator_TableClassName="TransactionsDataTable" msprop:Generator_TableVarName="tableTransactions" msprop:Generator_TablePropName="Transactions" msprop:Generator_RowDeletingName="TransactionsRowDeleting" msprop:Generator_UserTableName="Transactions" msprop:Generator_RowChangingName="TransactionsRowChanging" msprop:Generator_RowEvHandlerName="TransactionsRowChangeEventHandler" msprop:Generator_RowDeletedName="TransactionsRowDeleted" msprop:Generator_RowEvArgName="TransactionsRowChangeEvent" msprop:Generator_RowChangedName="TransactionsRowChanged" msprop:Generator_RowClassName="TransactionsRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="SNo" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnSNo" msprop:Generator_ColumnPropNameInRow="SNo" msprop:Generator_ColumnPropNameInTable="SNoColumn" msprop:Generator_UserColumnName="SNo" type="xs:long" />
              <xs:element name="Branch" msprop:Generator_ColumnVarNameInTable="columnBranch" msprop:Generator_ColumnPropNameInRow="Branch" msprop:Generator_ColumnPropNameInTable="BranchColumn" msprop:Generator_UserColumnName="Branch" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Source" msprop:Generator_ColumnVarNameInTable="columnSource" msprop:Generator_ColumnPropNameInRow="Source" msprop:Generator_ColumnPropNameInTable="SourceColumn" msprop:Generator_UserColumnName="Source" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="TransType" msprop:Generator_ColumnVarNameInTable="columnTransType" msprop:Generator_ColumnPropNameInRow="TransType" msprop:Generator_ColumnPropNameInTable="TransTypeColumn" msprop:Generator_UserColumnName="TransType" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="PaperNo" msprop:Generator_ColumnVarNameInTable="columnPaperNo" msprop:Generator_ColumnPropNameInRow="PaperNo" msprop:Generator_ColumnPropNameInTable="PaperNoColumn" msprop:Generator_UserColumnName="PaperNo" type="xs:long" minOccurs="0" />
              <xs:element name="MoveNo" msprop:Generator_ColumnVarNameInTable="columnMoveNo" msprop:Generator_ColumnPropNameInRow="MoveNo" msprop:Generator_ColumnPropNameInTable="MoveNoColumn" msprop:Generator_UserColumnName="MoveNo" type="xs:long" minOccurs="0" />
              <xs:element name="DestSource" msprop:Generator_ColumnVarNameInTable="columnDestSource" msprop:Generator_ColumnPropNameInRow="DestSource" msprop:Generator_ColumnPropNameInTable="DestSourceColumn" msprop:Generator_UserColumnName="DestSource" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="350" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ReceivedBy" msprop:Generator_ColumnVarNameInTable="columnReceivedBy" msprop:Generator_ColumnPropNameInRow="ReceivedBy" msprop:Generator_ColumnPropNameInTable="ReceivedByColumn" msprop:Generator_UserColumnName="ReceivedBy" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="500" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Descr" msprop:Generator_ColumnVarNameInTable="columnDescr" msprop:Generator_ColumnPropNameInRow="Descr" msprop:Generator_ColumnPropNameInTable="DescrColumn" msprop:Generator_UserColumnName="Descr" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="500" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="PolRef" msprop:Generator_ColumnVarNameInTable="columnPolRef" msprop:Generator_ColumnPropNameInRow="PolRef" msprop:Generator_ColumnPropNameInTable="PolRefColumn" msprop:Generator_UserColumnName="PolRef" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="350" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="AccNo" msprop:Generator_ColumnVarNameInTable="columnAccNo" msprop:Generator_ColumnPropNameInRow="AccNo" msprop:Generator_ColumnPropNameInTable="AccNoColumn" msprop:Generator_UserColumnName="AccNo" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="350" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Acc1" msprop:Generator_ColumnVarNameInTable="columnAcc1" msprop:Generator_ColumnPropNameInRow="Acc1" msprop:Generator_ColumnPropNameInTable="Acc1Column" msprop:Generator_UserColumnName="Acc1" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="500" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Acc2" msprop:Generator_ColumnVarNameInTable="columnAcc2" msprop:Generator_ColumnPropNameInRow="Acc2" msprop:Generator_ColumnPropNameInTable="Acc2Column" msprop:Generator_UserColumnName="Acc2" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="500" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Acc3" msprop:Generator_ColumnVarNameInTable="columnAcc3" msprop:Generator_ColumnPropNameInRow="Acc3" msprop:Generator_ColumnPropNameInTable="Acc3Column" msprop:Generator_UserColumnName="Acc3" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="500" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Acc4" msprop:Generator_ColumnVarNameInTable="columnAcc4" msprop:Generator_ColumnPropNameInRow="Acc4" msprop:Generator_ColumnPropNameInTable="Acc4Column" msprop:Generator_UserColumnName="Acc4" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="500" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ChNo" msprop:Generator_ColumnVarNameInTable="columnChNo" msprop:Generator_ColumnPropNameInRow="ChNo" msprop:Generator_ColumnPropNameInTable="ChNoColumn" msprop:Generator_UserColumnName="ChNo" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="500" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="TotalIn" msprop:Generator_ColumnVarNameInTable="columnTotalIn" msprop:Generator_ColumnPropNameInRow="TotalIn" msprop:Generator_ColumnPropNameInTable="TotalInColumn" msprop:Generator_UserColumnName="TotalIn" type="xs:double" minOccurs="0" />
              <xs:element name="TotalOut" msprop:Generator_ColumnVarNameInTable="columnTotalOut" msprop:Generator_ColumnPropNameInRow="TotalOut" msprop:Generator_ColumnPropNameInTable="TotalOutColumn" msprop:Generator_UserColumnName="TotalOut" type="xs:double" minOccurs="0" />
              <xs:element name="Writting" msprop:Generator_ColumnVarNameInTable="columnWritting" msprop:Generator_ColumnPropNameInRow="Writting" msprop:Generator_ColumnPropNameInTable="WrittingColumn" msprop:Generator_UserColumnName="Writting" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="550" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Reversed" msprop:Generator_ColumnVarNameInTable="columnReversed" msprop:Generator_ColumnPropNameInRow="Reversed" msprop:Generator_ColumnPropNameInTable="ReversedColumn" msprop:Generator_UserColumnName="Reversed" type="xs:int" minOccurs="0" />
              <xs:element name="SavedUser" msprop:Generator_ColumnVarNameInTable="columnSavedUser" msprop:Generator_ColumnPropNameInRow="SavedUser" msprop:Generator_ColumnPropNameInTable="SavedUserColumn" msprop:Generator_UserColumnName="SavedUser" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="250" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="TransDate" msprop:Generator_ColumnVarNameInTable="columnTransDate" msprop:Generator_ColumnPropNameInRow="TransDate" msprop:Generator_ColumnPropNameInTable="TransDateColumn" msprop:Generator_UserColumnName="TransDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="ApprovedUser" msprop:Generator_ColumnVarNameInTable="columnApprovedUser" msprop:Generator_ColumnPropNameInRow="ApprovedUser" msprop:Generator_ColumnPropNameInTable="ApprovedUserColumn" msprop:Generator_UserColumnName="ApprovedUser" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="250" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ApprovedDate" msprop:Generator_ColumnVarNameInTable="columnApprovedDate" msprop:Generator_ColumnPropNameInRow="ApprovedDate" msprop:Generator_ColumnPropNameInTable="ApprovedDateColumn" msprop:Generator_UserColumnName="ApprovedDate" type="xs:dateTime" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Transactions" />
      <xs:field xpath="mstns:SNo" />
    </xs:unique>
  </xs:element>
</xs:schema>